﻿CREATE TABLE [dbo].[FilteredEvents] (
	[ID]             INT  IDENTITY(1,1) NOT NULL,
    [MeterNumber]    NVARCHAR (50) NOT NULL,
    [MeterVendorID]  NVARCHAR (50) NOT NULL,
    [MeterHeadEndID] NVARCHAR (50) NOT NULL,
    [TimeStamp]      DATETIME      NOT NULL,
    [EventType]      NVARCHAR (50) NOT NULL,
    [Reading]        FLOAT         NOT NULL,
    [Temp]           FLOAT         NOT NULL,
    [Code]           NVARCHAR (50) NOT NULL,
    [Status]         NVARCHAR (50) NOT NULL
);

